﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Sablon.Master" AutoEventWireup="true" CodeBehind="musterihareketleri.aspx.cs" Inherits="OnlineDovizOtomasyonu.musterihareketleri" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxRoundPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxHtmlEditor.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxHtmlEditor" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxSpellChecker.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxSpellChecker" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxSplitter" tagprefix="dx" %>
<%@ Register assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table border="0" cellspacing="0" cellpadding="0" width="100%">
	<tr>
		<td width="100">Müşteri Group</td>
		<td width="5">:</td>
		<td width="150">
                                                    <dx:ASPxComboBox runat="server" 
                DropDownStyle="DropDown" EnableIncrementalFiltering="True" 
                IncrementalFilteringMode="StartsWith" DataSourceID="sdmusterigroup" 
                TextField="ADI" ValueField="ID" TextFormatString="{1}" 
                LoadingPanelText="Y&#252;kleniyor..." Width="100%" AutoPostBack="True" 
                Theme="Aqua" ID="txtMusteriGroup" 
                OnSelectedIndexChanged="txtMusteriGroup_SelectedIndexChanged"><Columns>
<dx:ListBoxColumn FieldName="KODU" Width="100px" Caption="Group Kodu"></dx:ListBoxColumn>
<dx:ListBoxColumn FieldName="ADI" Width="200px" Caption="Group Adı"></dx:ListBoxColumn>
</Columns>

<ValidationSettings ErrorDisplayMode="ImageWithTooltip">
<RequiredField IsRequired="True" ErrorText="M&#252;şteri Gurubunu Se&#231;iniz!"></RequiredField>
</ValidationSettings>
</dx:ASPxComboBox>



                                                    <asp:SqlDataSource runat="server" ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" SelectCommand="SELECT [ID], [KODU], [ADI] FROM [WEBINGDOVIZ_TBLGROUP] ORDER BY [ID]" ID="sdmusterigroup"></asp:SqlDataSource>



                                                </td>
		<td width="10">&nbsp;</td>
		<td width="100" align="right">Müşteri Adı</td>
		<td width="5">:</td>
		<td width="200">
                                                    <dx:ASPxComboBox runat="server" 
                EnableIncrementalFiltering="True" IncrementalFilteringMode="StartsWith" 
                DataSourceID="sdMusteriBilgileri" ValueField="ID" TextFormatString="{1}" 
                LoadingPanelText="Y&#252;kleniyor..." Width="100%" AutoPostBack="True" 
                Theme="Aqua" TabIndex="1" ID="txtMusteriKodu" 
                OnSelectedIndexChanged="txtMusteriKodu_SelectedIndexChanged"><Columns>
<dx:ListBoxColumn FieldName="KODU" Width="75px" Caption="Kodu"></dx:ListBoxColumn>
<dx:ListBoxColumn FieldName="ADI" Width="150px" Caption="M&#252;şteri Adı"></dx:ListBoxColumn>
</Columns>

<ValidationSettings ErrorDisplayMode="ImageWithTooltip">
<RequiredField IsRequired="True" ErrorText="M&#252;şteri Se&#231;iniz!"></RequiredField>
</ValidationSettings>
</dx:ASPxComboBox>



                                                    <asp:SqlDataSource runat="server" ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" SelectCommand="SELECT [ID], [KODU], [ADI], [GRUP] FROM [WEBINGDOVIZ_TBLCARI] WHERE ([GRUP] = @GRUP) ORDER BY [ADI]" ID="sdMusteriBilgileri"><SelectParameters>
<asp:ControlParameter ControlID="txtMusteriGroup" PropertyName="Value" Name="GRUP" Type="Int32"></asp:ControlParameter>
</SelectParameters>
</asp:SqlDataSource>



                                                </td>
        <td></td>
	</tr>
</table>
    <table cellpadding="0" cellspacing="0" class="style1">
        <tr>
            <td align="left" height="100%" valign="top" width="100%">
                
                <dx:ASPxSplitter ID="SplitterGenel" runat="server" FullscreenMode="True" 
                    Height="100%" ShowCollapseBackwardButton="True" 
                    ShowCollapseForwardButton="True" Theme="Aqua" Width="100%">
                    <panes>
                        <dx:SplitterPane>
                            <ContentCollection>
<dx:SplitterContentControl runat="server" SupportsDisabledAttribute="True">
    <table cellpadding="0" cellspacing="0" class="style1">
        <tr>
            <td align="left" height="100%" valign="top">
                <dx:ASPxGridView ID="ListeAlacak" runat="server" AutoGenerateColumns="False" 
                    ClientInstanceName="ListeAlacak" DataSourceID="sdAlacakVeri" 
                    KeyFieldName="ID" TabIndex="14" Theme="Aqua" 
                    Width="100%" Caption="Alacak">
                    <TotalSummary>
                        <dx:ASPxSummaryItem ShowInColumn="TL" SummaryType="Sum" />
                    </TotalSummary>
                    <GroupSummary>
                        <dx:ASPxSummaryItem />
                    </GroupSummary>
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="ID" ReadOnly="True" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="1">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="2" Width="10%">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="TL" Name="TL" 
                            ShowInCustomizationForm="True" VisibleIndex="4" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="USD" Name="USD" 
                            ShowInCustomizationForm="True" VisibleIndex="5" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="EURO" Name="EURO" 
                            ShowInCustomizationForm="True" VisibleIndex="6" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SAR" Name="SAR" 
                            ShowInCustomizationForm="True" VisibleIndex="7" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SRY" Name="SRY" 
                            ShowInCustomizationForm="True" VisibleIndex="8" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            VisibleIndex="9" Width="40%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="10">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowFocusedRow="True" />
                    <SettingsPager PageSize="15" RenderMode="Lightweight" AlwaysShowPager="True">
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıt)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <SettingsText EmptyDataRow="Alacak Verisi Bulunamadı!" 
                        EmptyHeaders="Kolon Sürükleyin..." 
                        GroupPanel="Guruplma Yapmak İstediğiniz Kolonu Sürükleyiniz." />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                    <Styles>
                        <SelectedRow BackColor="#99CCFF">
                        </SelectedRow>
                        <FocusedRow BackColor="#99CCFF">
                        </FocusedRow>
                    </Styles>
                    <StylesEditors>
                        <Focused BackColor="#FF9900">
                        </Focused>
                    </StylesEditors>
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdAlacakVeri" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [TBLDEFTER] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TIPI] = @TIPI) AND ([KESIM] = @KESIM)) ORDER BY [ID] DESC">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:Parameter DefaultValue="A" Name="TIPI" Type="String" />
                        <asp:Parameter DefaultValue="0" Name="KESIM" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
                                </dx:SplitterContentControl>
</ContentCollection>
                        </dx:SplitterPane>
                        <dx:SplitterPane>
                            <ContentCollection>
<dx:SplitterContentControl runat="server" SupportsDisabledAttribute="True">
    <table cellpadding="0" cellspacing="0" class="style1">
        <tr>
            <td align="left" height="100%" valign="top">
                <dx:ASPxGridView ID="ListeVerecek" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="sdVerecekVeri" KeyFieldName="ID" TabIndex="14" Theme="Aqua" 
                    Width="100%" Caption="Verecek">
                    <Columns>
                        <dx:GridViewDataTextColumn FieldName="ID" ReadOnly="True" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="0">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="MUSTERIKODU" 
                            ShowInCustomizationForm="True" Visible="False" VisibleIndex="1">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn FieldName="TARIH" ShowInCustomizationForm="True" 
                            VisibleIndex="2" Width="10%">
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPI" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="TL" Name="TL" 
                            ShowInCustomizationForm="True" VisibleIndex="4" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="USD" Name="USD" 
                            ShowInCustomizationForm="True" VisibleIndex="5" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="EURO" Name="EURO" 
                            ShowInCustomizationForm="True" VisibleIndex="6" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SAR" Name="SAR" 
                            ShowInCustomizationForm="True" VisibleIndex="7" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="SRY" Name="SRY" 
                            ShowInCustomizationForm="True" VisibleIndex="8" Width="10%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ACIKLAMA" ShowInCustomizationForm="True" 
                            VisibleIndex="9" Width="40%">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="KESIM" ShowInCustomizationForm="True" 
                            Visible="False" VisibleIndex="10">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <SettingsBehavior AllowFocusedRow="True" />
                    <SettingsPager PageSize="15" RenderMode="Lightweight" AlwaysShowPager="True">
                        <Summary AllPagesText="Sayfalar: {0} - {1} ({2} Kayıt)" 
                            Text="Sayfa {0} İle {1} ({2} Kayıt)" />
                    </SettingsPager>
                    <SettingsText EmptyDataRow="Verecek Verisi Bulunamadı!" 
                        EmptyHeaders="Kolon Sürükleyin..." 
                        GroupPanel="Guruplma Yapmak İstediğiniz Kolonu Sürükleyiniz." />
                    <SettingsLoadingPanel Text="Lütfen Bekleyin..." />
                    <Styles>
                        <SelectedRow BackColor="#99CCFF">
                        </SelectedRow>
                        <FocusedRow BackColor="#99CCFF">
                        </FocusedRow>
                    </Styles>
                    <StylesEditors>
                        <Focused BackColor="#FF9900">
                        </Focused>
                    </StylesEditors>
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="sdVerecekVeri" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:webingdovizlistelericinbaglanti %>" 
                    SelectCommand="SELECT * FROM [TBLDEFTER] WHERE (([MUSTERIKODU] = @MUSTERIKODU) AND ([TIPI] = @TIPI) AND ([KESIM] = @KESIM))">
                    <SelectParameters>
                        <asp:SessionParameter DefaultValue="-1" Name="MUSTERIKODU" 
                            SessionField="webingMK" Type="Int32" />
                        <asp:Parameter DefaultValue="V" Name="TIPI" Type="String" />
                        <asp:Parameter DefaultValue="0" Name="KESIM" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
                                </dx:SplitterContentControl>
</ContentCollection>
                        </dx:SplitterPane>
                    </panes>
                </dx:ASPxSplitter>
                
            </td>
        </tr>
        </table>
</asp:Content>
